home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presentation Library 1993 Spring / ARPL-Spring-93-Partner-Edition.iso / Applications / Databases / GQL V3.0 Demo / USA Sales Information / USA Sales Information.rsrc / gDEM_23506_Top Sales < prev    next >
Encoding:
Text File  |  1992-01-27  |  235 b   |  1 lines
  1. select staff.first_name, staff.last_name, offices.region, orders.ord_amount from staff, offices, orders where ((orders.ord_amount > $50000)) and staff.rep_office = offices.office_nr and staff.rep_nr = orders.salesrep order by 4 desc ;